EDA

Dataset statistics

Number of variables	15
Number of observations	148248
Missing cells	88239
Missing cells (%)	4.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	35.3 MiB
Average record size in memory	249.7 B

Variable types

Numeric	3
TimeSeries	10
Categorical	2

Alerts

`data_hora` has a high cardinality: 148248 distinct values	High cardinality
`pressao` is highly overall correlated with `temperatura_orvalho`	High correlation
`radiacao` is highly overall correlated with `temperatura` and 3 other fields	High correlation
`temperatura` is highly overall correlated with `radiacao` and 5 other fields	High correlation
`temperatura_orvalho` is highly overall correlated with `pressao`	High correlation
`temp_max_hr_anterior` is highly overall correlated with `radiacao` and 5 other fields	High correlation
`temp_min_hr_anterior` is highly overall correlated with `temperatura` and 4 other fields	High correlation
`umidade_max_hr_anterior` is highly overall correlated with `temperatura` and 4 other fields	High correlation
`umidade_min_hr_anterior` is highly overall correlated with `radiacao` and 5 other fields	High correlation
`umidade` is highly overall correlated with `radiacao` and 5 other fields	High correlation
`chuva` has 7215 (4.9%) missing values	Missing
`pressao` has 7056 (4.8%) missing values	Missing
`radiacao` has 7099 (4.8%) missing values	Missing
`temperatura` has 7056 (4.8%) missing values	Missing
`temperatura_orvalho` has 7285 (4.9%) missing values	Missing
`temp_max_hr_anterior` has 7470 (5.0%) missing values	Missing
`temp_min_hr_anterior` has 7470 (5.0%) missing values	Missing
`umidade_max_hr_anterior` has 7710 (5.2%) missing values	Missing
`umidade_min_hr_anterior` has 7710 (5.2%) missing values	Missing
`umidade` has 7284 (4.9%) missing values	Missing
`vento_direcao` has 7442 (5.0%) missing values	Missing
`vento_velocidade` has 7442 (5.0%) missing values	Missing
`pressao` is non stationary	Non stationary
`radiacao` is non stationary	Non stationary
`temperatura` is non stationary	Non stationary
`temperatura_orvalho` is non stationary	Non stationary
`temp_max_hr_anterior` is non stationary	Non stationary
`temp_min_hr_anterior` is non stationary	Non stationary
`umidade_max_hr_anterior` is non stationary	Non stationary
`umidade_min_hr_anterior` is non stationary	Non stationary
`umidade` is non stationary	Non stationary
`pressao` is seasonal	Seasonal
`radiacao` is seasonal	Seasonal
`temperatura` is seasonal	Seasonal
`temperatura_orvalho` is seasonal	Seasonal
`temp_max_hr_anterior` is seasonal	Seasonal
`temp_min_hr_anterior` is seasonal	Seasonal
`umidade_max_hr_anterior` is seasonal	Seasonal
`umidade_min_hr_anterior` is seasonal	Seasonal
`umidade` is seasonal	Seasonal
`data_hora` is uniformly distributed	Uniform
`time` is uniformly distributed	Uniform
`data_hora` has unique values	Unique
`time` has unique values	Unique
`chuva` has 129512 (87.4%) zeros	Zeros
`vento_velocidade` has 3827 (2.6%) zeros	Zeros

Reproduction

Analysis started	2023-05-08 14:01:54.528434
Analysis finished	2023-05-08 14:16:33.501404
Duration	14 minutes and 38.97 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

chuva
Real number (ℝ)

MISSING ZEROS

Distinct	164
Distinct (%)	0.1%
Missing	7215
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.17850716

Minimum	0
Maximum	74.8
Zeros	129512
Zeros (%)	87.4%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.4
Maximum	74.8
Range	74.8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3041834
Coefficient of variation (CV)	7.3060566
Kurtosis	400.00234
Mean	0.17850716
Median Absolute Deviation (MAD)	0
Skewness	15.914505
Sum	25175.4
Variance	1.7008943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	129512	87.4%
0.2	3782	2.6%
0.4	1214	0.8%
0.6	797	0.5%
0.8	639	0.4%
1	499	0.3%
1.2	418	0.3%
1.4	344	0.2%
1.6	287	0.2%
1.8	275	0.2%
Other values (154)	3266	2.2%
(Missing)	7215	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	129512	87.4%
0.2	3782	2.6%
0.4	1214	0.8%
0.6	797	0.5%
0.8	639	0.4%
1	499	0.3%
1.2	418	0.3%
1.4	344	0.2%
1.6	287	0.2%
1.8	275	0.2%

Value	Count	Frequency (%)
74.8	1	< 0.1%
64.4	1	< 0.1%
53.4	1	< 0.1%
48.4	1	< 0.1%
46.4	1	< 0.1%
46.2	1	< 0.1%
44	1	< 0.1%
41.8	1	< 0.1%
41.4	1	< 0.1%
40.6	2	< 0.1%

pressao
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	250
Distinct (%)	0.2%
Missing	7056
Missing (%)	4.8%
Infinite	0
Infinite (%)	0.0%

Mean	910.61991
Minimum	897.7
Maximum	923.3
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	897.7
5-th percentile	905.4
Q1	908.4
median	910.4
Q3	912.8
95-th percentile	916.3
Maximum	923.3
Range	25.6
Interquartile range (IQR)	4.4

Descriptive statistics

Standard deviation	3.3151153
Coefficient of variation (CV)	0.0036405039
Kurtosis	-0.0063468342
Mean	910.61991
Median Absolute Deviation (MAD)	2.2
Skewness	0.1412564
Sum	1.2857225 × 10⁸
Variance	10.98999
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	2.493980372 × 10^-30

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
910	1885	1.3%
909.7	1850	1.2%
909.8	1800	1.2%
910.1	1789	1.2%
910.7	1783	1.2%
910.8	1781	1.2%
910.5	1778	1.2%
909.5	1776	1.2%
909.3	1776	1.2%
909.1	1771	1.2%
Other values (240)	123203	83.1%
(Missing)	7056	4.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
897.7	1	< 0.1%
898.2	2	< 0.1%
898.3	1	< 0.1%
898.4	2	< 0.1%
898.5	3	< 0.1%
898.6	2	< 0.1%
898.8	2	< 0.1%
898.9	1	< 0.1%
899	5	< 0.1%
899.1	1	< 0.1%

Value	Count	Frequency (%)
923.3	1	< 0.1%
923.1	1	< 0.1%
923	1	< 0.1%
922.9	2	< 0.1%
922.7	1	< 0.1%
922.6	1	< 0.1%
922.5	2	< 0.1%
922.4	4	< 0.1%
922.3	2	< 0.1%
922.2	2	< 0.1%

ACF and PACF

radiacao
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	61390
Distinct (%)	43.5%
Missing	7099
Missing (%)	4.8%
Infinite	0
Infinite (%)	0.0%

Mean	495705.76
Minimum	-3538
Maximum	4385403
Zeros	1209
Zeros (%)	0.8%
Memory size	1.1 MiB

Quantile statistics

Minimum	-3538
5-th percentile	-3279
Q1	-3.54
median	278
Q3	520021
95-th percentile	2733951.4
Maximum	4385403
Range	4388941
Interquartile range (IQR)	520024.54

Descriptive statistics

Standard deviation	927767.25
Coefficient of variation (CV)	1.8716088
Kurtosis	2.1949135
Mean	495705.76
Median Absolute Deviation (MAD)	2235
Skewness	1.841436
Sum	6.9968373 × 10¹⁰
Variance	8.6075207 × 10¹¹
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	4.424938881 × 10^-26

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3.54	21888	14.8%
-4	9989	6.7%
-3	4037	2.7%
-2	2204	1.5%
-1	1382	0.9%
0	1209	0.8%
-3538	727	0.5%
-3536	401	0.3%
-0.12	263	0.2%
-3535	260	0.2%
Other values (61380)	98789	66.6%
(Missing)	7099	4.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3538	727	0.5%
-3536	401	0.3%
-3535	260	0.2%
-3533	236	0.2%
-3531	173	0.1%
-3529	168	0.1%
-3528	159	0.1%
-3526	144	0.1%
-3524	108	0.1%
-3523	3	< 0.1%

Value	Count	Frequency (%)
4385403	1	< 0.1%
4376379	1	< 0.1%
4322411	1	< 0.1%
4258305	1	< 0.1%
4250522	1	< 0.1%
4237973	1	< 0.1%
4232222	1	< 0.1%
4223379	1	< 0.1%
4218294	1	< 0.1%
4201529	1	< 0.1%

ACF and PACF

temperatura
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	334
Distinct (%)	0.2%
Missing	7056
Missing (%)	4.8%
Infinite	0
Infinite (%)	0.0%

Mean	19.779273
Minimum	1.6
Maximum	37.6
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1.6
5-th percentile	11.5
Q1	16.7
median	19.5
Q3	23.1
95-th percentile	28.2
Maximum	37.6
Range	36
Interquartile range (IQR)	6.4

Descriptive statistics

Standard deviation	4.9238106
Coefficient of variation (CV)	0.2489379
Kurtosis	-0.16249713
Mean	19.779273
Median Absolute Deviation (MAD)	3.2
Skewness	0.0038725063
Sum	2792675.1
Variance	24.243911
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	1.611479827 × 10^-29

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	1557	1.1%
18.8	1555	1.0%
19.4	1517	1.0%
19.1	1508	1.0%
19.3	1504	1.0%
18.9	1500	1.0%
19	1489	1.0%
18.6	1468	1.0%
18.7	1452	1.0%
19.7	1436	1.0%
Other values (324)	126206	85.1%
(Missing)	7056	4.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.6	1	< 0.1%
2.1	1	< 0.1%
2.5	2	< 0.1%
3.2	2	< 0.1%
3.4	1	< 0.1%
3.5	2	< 0.1%
3.6	1	< 0.1%
3.7	2	< 0.1%
3.8	5	< 0.1%
3.9	5	< 0.1%

Value	Count	Frequency (%)
37.6	1	< 0.1%
36.8	1	< 0.1%
36.7	1	< 0.1%
36.5	1	< 0.1%
36.4	1	< 0.1%
36.3	1	< 0.1%
36.2	1	< 0.1%
35.8	2	< 0.1%
35.7	2	< 0.1%
35.6	1	< 0.1%

ACF and PACF

temperatura_orvalho
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	265
Distinct (%)	0.2%
Missing	7285
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%

Mean	14.365055
Minimum	-6.3
Maximum	25.6
Zeros	3
Zeros (%)	< 0.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	-6.3
5-th percentile	7.7
Q1	11.9
median	15
Q3	17.3
95-th percentile	19.1
Maximum	25.6
Range	31.9
Interquartile range (IQR)	5.4

Descriptive statistics

Standard deviation	3.658414
Coefficient of variation (CV)	0.25467456
Kurtosis	0.043476628
Mean	14.365055
Median Absolute Deviation (MAD)	2.6
Skewness	-0.69845588
Sum	2024941.2
Variance	13.383993
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	7.486805007 × 10^-27

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	1860	1.3%
17.1	1831	1.2%
17.9	1828	1.2%
17.4	1825	1.2%
17.5	1821	1.2%
17.6	1820	1.2%
17.8	1820	1.2%
17.3	1784	1.2%
17	1779	1.2%
17.2	1774	1.2%
Other values (255)	122821	82.8%
(Missing)	7285	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.3	1	< 0.1%
-6.1	1	< 0.1%
-5.9	2	< 0.1%
-5.5	2	< 0.1%
-5.3	1	< 0.1%
-5.1	1	< 0.1%
-4.9	2	< 0.1%
-4.7	1	< 0.1%
-4.3	2	< 0.1%
-3.7	2	< 0.1%

Value	Count	Frequency (%)
25.6	1	< 0.1%
24.6	1	< 0.1%
23	1	< 0.1%
22.6	1	< 0.1%
22.5	2	< 0.1%
22.4	2	< 0.1%
22.2	2	< 0.1%
22.1	5	< 0.1%
22	4	< 0.1%
21.9	5	< 0.1%

ACF and PACF

temp_max_hr_anterior
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	338
Distinct (%)	0.2%
Missing	7470
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.51523
Minimum	2.1
Maximum	37.8
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	2.1
5-th percentile	12.1
Q1	17.3
median	20.1
Q3	24.1
95-th percentile	29.2
Maximum	37.8
Range	35.7
Interquartile range (IQR)	6.8

Descriptive statistics

Standard deviation	5.1140667
Coefficient of variation (CV)	0.24928147
Kurtosis	-0.29493851
Mean	20.51523
Median Absolute Deviation (MAD)	3.4
Skewness	0.039513306
Sum	2888093
Variance	26.153678
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	1.261188546 × 10^-29

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	1525	1.0%
19.1	1437	1.0%
19.5	1430	1.0%
19.3	1407	0.9%
19	1403	0.9%
19.4	1389	0.9%
18.9	1376	0.9%
18.8	1376	0.9%
19.7	1367	0.9%
19.9	1364	0.9%
Other values (328)	126704	85.5%
(Missing)	7470	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.1	1	< 0.1%
2.5	1	< 0.1%
3.3	1	< 0.1%
3.5	1	< 0.1%
3.8	2	< 0.1%
3.9	4	< 0.1%
4	1	< 0.1%
4.1	1	< 0.1%
4.3	1	< 0.1%
4.4	2	< 0.1%

Value	Count	Frequency (%)
37.8	1	< 0.1%
37.6	1	< 0.1%
37.4	1	< 0.1%
37.2	1	< 0.1%
37	1	< 0.1%
36.9	1	< 0.1%
36.7	2	< 0.1%
36.6	1	< 0.1%
36.4	2	< 0.1%
36.3	1	< 0.1%

ACF and PACF

temp_min_hr_anterior
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	322
Distinct (%)	0.2%
Missing	7470
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%

Mean	19.08855
Minimum	1.4
Maximum	36.2
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1.4
5-th percentile	11
Q1	16.2
median	19
Q3	22.1
95-th percentile	27.1
Maximum	36.2
Range	34.8
Interquartile range (IQR)	5.9

Descriptive statistics

Standard deviation	4.7489778
Coefficient of variation (CV)	0.24878672
Kurtosis	-0.068652947
Mean	19.08855
Median Absolute Deviation (MAD)	3
Skewness	-0.055497642
Sum	2687247.9
Variance	22.55279
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	5.992739738 × 10^-28

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	1645	1.1%
18.7	1637	1.1%
19	1590	1.1%
19.1	1588	1.1%
18.8	1588	1.1%
18.6	1576	1.1%
18.9	1573	1.1%
18.4	1525	1.0%
19.3	1518	1.0%
19.4	1515	1.0%
Other values (312)	125023	84.3%
(Missing)	7470	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.4	2	< 0.1%
1.9	1	< 0.1%
2.5	4	< 0.1%
2.6	2	< 0.1%
2.9	1	< 0.1%
3.1	1	< 0.1%
3.2	2	< 0.1%
3.4	1	< 0.1%
3.5	4	< 0.1%
3.6	2	< 0.1%

Value	Count	Frequency (%)
36.2	1	< 0.1%
35.4	3	< 0.1%
35	1	< 0.1%
34.8	1	< 0.1%
34.7	1	< 0.1%
34.6	2	< 0.1%
34.5	1	< 0.1%
34.3	4	< 0.1%
34.2	1	< 0.1%
33.9	1	< 0.1%

ACF and PACF

umidade_max_hr_anterior
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	89
Distinct (%)	0.1%
Missing	7710
Missing (%)	5.2%
Infinite	0
Infinite (%)	0.0%

Mean	77.607501
Minimum	12
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	12
5-th percentile	41
Q1	65
median	84
Q3	93
95-th percentile	97
Maximum	100
Range	88
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	18.409207
Coefficient of variation (CV)	0.23720912
Kurtosis	-0.096974941
Mean	77.607501
Median Absolute Deviation (MAD)	11
Skewness	-0.92742198
Sum	10906803
Variance	338.8989
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
96	7879	5.3%
95	7333	4.9%
94	6526	4.4%
97	5873	4.0%
93	5852	3.9%
92	5666	3.8%
91	4765	3.2%
90	4223	2.8%
89	3925	2.6%
88	3667	2.5%
Other values (79)	84829	57.2%
(Missing)	7710	5.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	1	< 0.1%
13	3	< 0.1%
14	7	< 0.1%
15	4	< 0.1%
16	4	< 0.1%
17	19	< 0.1%
18	41	< 0.1%
19	59	< 0.1%
20	63	< 0.1%
21	85	0.1%

Value	Count	Frequency (%)
100	763	0.5%
99	619	0.4%
98	2525	1.7%
97	5873	4.0%
96	7879	5.3%
95	7333	4.9%
94	6526	4.4%
93	5852	3.9%
92	5666	3.8%
91	4765	3.2%

ACF and PACF

umidade_min_hr_anterior
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	91
Distinct (%)	0.1%
Missing	7710
Missing (%)	5.2%
Infinite	0
Infinite (%)	0.0%

Mean	71.164375
Minimum	10
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	10
5-th percentile	33
Q1	55
median	76
Q3	89
95-th percentile	96
Maximum	100
Range	90
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	20.584654
Coefficient of variation (CV)	0.28925503
Kurtosis	-0.74895319
Mean	71.164375
Median Absolute Deviation (MAD)	15
Skewness	-0.60309458
Sum	10001299
Variance	423.72797
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
92	4284	2.9%
94	4182	2.8%
93	4092	2.8%
91	4042	2.7%
95	4012	2.7%
90	3896	2.6%
96	3825	2.6%
89	3667	2.5%
88	3531	2.4%
87	3407	2.3%
Other values (81)	101600	68.5%
(Missing)	7710	5.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	6	< 0.1%
11	4	< 0.1%
12	11	< 0.1%
13	16	< 0.1%
14	37	< 0.1%
15	62	< 0.1%
16	72	< 0.1%
17	117	0.1%
18	115	0.1%
19	143	0.1%

Value	Count	Frequency (%)
100	358	0.2%
99	329	0.2%
98	1420	1.0%
97	3033	2.0%
96	3825	2.6%
95	4012	2.7%
94	4182	2.8%
93	4092	2.8%
92	4284	2.9%
91	4042	2.7%

ACF and PACF

umidade
Numeric time series

HIGH CORRELATION MISSING NON STATIONARY SEASONAL

Distinct	90
Distinct (%)	0.1%
Missing	7284
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%

Mean	74.412027
Minimum	11
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	11
5-th percentile	37
Q1	60
median	80
Q3	91
95-th percentile	97
Maximum	100
Range	89
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	19.634934
Coefficient of variation (CV)	0.26386775
Kurtosis	-0.47736995
Mean	74.412027
Median Absolute Deviation (MAD)	13
Skewness	-0.75540489
Sum	10489417
Variance	385.53064
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
96	5698	3.8%
95	5662	3.8%
94	5341	3.6%
92	5042	3.4%
93	5014	3.4%
91	4431	3.0%
97	4320	2.9%
90	4104	2.8%
89	3809	2.6%
88	3669	2.5%
Other values (80)	93874	63.3%
(Missing)	7284	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	2	< 0.1%
12	5	< 0.1%
13	11	< 0.1%
14	9	< 0.1%
15	18	< 0.1%
16	34	< 0.1%
17	77	0.1%
18	75	0.1%
19	92	0.1%
20	107	0.1%

Value	Count	Frequency (%)
100	552	0.4%
99	461	0.3%
98	1909	1.3%
97	4320	2.9%
96	5698	3.8%
95	5662	3.8%
94	5341	3.6%
93	5014	3.4%
92	5042	3.4%
91	4431	3.0%

ACF and PACF

vento_direcao
Real number (ℝ)

Distinct	360
Distinct (%)	0.3%
Missing	7442
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	151.34381

Minimum	1
Maximum	360
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	22
Q1	87
median	134
Q3	193
95-th percentile	337
Maximum	360
Range	359
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	94.082834
Coefficient of variation (CV)	0.62164971
Kurtosis	-0.45672998
Mean	151.34381
Median Absolute Deviation (MAD)	52
Skewness	0.6594246
Sum	21310116
Variance	8851.5796
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
138	1406	0.9%
136	1388	0.9%
134	1349	0.9%
131	1329	0.9%
137	1327	0.9%
139	1318	0.9%
130	1316	0.9%
133	1309	0.9%
140	1303	0.9%
135	1296	0.9%
Other values (350)	127465	86.0%
(Missing)	7442	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	270	0.2%
2	296	0.2%
3	273	0.2%
4	286	0.2%
5	331	0.2%
6	277	0.2%
7	300	0.2%
8	276	0.2%
9	325	0.2%
10	301	0.2%

Value	Count	Frequency (%)
360	262	0.2%
359	269	0.2%
358	290	0.2%
357	281	0.2%
356	275	0.2%
355	263	0.2%
354	275	0.2%
353	293	0.2%
352	305	0.2%
351	278	0.2%

vento_velocidade
Real number (ℝ)

MISSING ZEROS

Distinct	132
Distinct (%)	0.1%
Missing	7442
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4001285

Minimum	0
Maximum	15.5
Zeros	3827
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.2
Q1	1.2
median	2.1
Q3	3.3
95-th percentile	5.3
Maximum	15.5
Range	15.5
Interquartile range (IQR)	2.1

Descriptive statistics

Standard deviation	1.5862629
Coefficient of variation (CV)	0.66090746
Kurtosis	1.3781604
Mean	2.4001285
Median Absolute Deviation (MAD)	1
Skewness	0.94531105
Sum	337952.5
Variance	2.5162299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5	4107	2.8%
1.4	4081	2.8%
1.3	4064	2.7%
1.7	3999	2.7%
1.6	3995	2.7%
1.2	3949	2.7%
1.8	3920	2.6%
0	3827	2.6%
1.9	3802	2.6%
2	3789	2.6%
Other values (122)	101273	68.3%
(Missing)	7442	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3827	2.6%
0.1	1916	1.3%
0.2	1829	1.2%
0.3	2010	1.4%
0.4	1985	1.3%
0.5	2202	1.5%
0.6	2296	1.5%
0.7	2603	1.8%
0.8	2764	1.9%
0.9	3219	2.2%

Value	Count	Frequency (%)
15.5	1	< 0.1%
14.8	1	< 0.1%
14.6	1	< 0.1%
14.3	2	< 0.1%
13.3	1	< 0.1%
13.2	2	< 0.1%
12.8	2	< 0.1%
12.7	3	< 0.1%
12.5	3	< 0.1%
12.2	3	< 0.1%

data_hora
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	148248
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	10.7 MiB

2006-06-08 00:00:00	1
2017-09-18 00:00:00	1
2017-09-15 20:00:00	1
2017-09-15 21:00:00	1
2017-09-15 22:00:00	1
Other values (148243)	148243

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2816712
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	148248 ?
Unique (%)	100.0%

Sample

1st row	2006-06-08 00:00:00
2nd row	2006-06-08 01:00:00
3rd row	2006-06-08 02:00:00
4th row	2006-06-08 03:00:00
5th row	2006-06-08 04:00:00

Common Values

Value	Count	Frequency (%)
2006-06-08 00:00:00	1	< 0.1%
2017-09-18 00:00:00	1	< 0.1%
2017-09-15 20:00:00	1	< 0.1%
2017-09-15 21:00:00	1	< 0.1%
2017-09-15 22:00:00	1	< 0.1%
2017-09-15 23:00:00	1	< 0.1%
2017-09-16 00:00:00	1	< 0.1%
2017-09-16 01:00:00	1	< 0.1%
2017-09-16 02:00:00	1	< 0.1%
2017-09-16 03:00:00	1	< 0.1%
Other values (148238)	148238	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
12:00:00	6177	2.1%
06:00:00	6177	2.1%
15:00:00	6177	2.1%
14:00:00	6177	2.1%
13:00:00	6177	2.1%
11:00:00	6177	2.1%
16:00:00	6177	2.1%
17:00:00	6177	2.1%
18:00:00	6177	2.1%
19:00:00	6177	2.1%
Other values (6191)	234726	79.2%

Most occurring characters

Value	Count	Frequency (%)
0	1051749	37.3%
2	325551	11.6%
1	314061	11.1%
-	296496	10.5%
:	296496	10.5%
	148248	5.3%
3	64875	2.3%
8	57162	2.0%
7	57114	2.0%
9	56418	2.0%
Other values (3)	148542	5.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2075472	73.7%
Dash Punctuation	296496	10.5%
Other Punctuation	296496	10.5%
Space Separator	148248	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1051749	50.7%
2	325551	15.7%
1	314061	15.1%
3	64875	3.1%
8	57162	2.8%
7	57114	2.8%
9	56418	2.7%
6	52794	2.5%
4	47970	2.3%
5	47778	2.3%

Dash Punctuation

Value	Count	Frequency (%)
-	296496	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	296496	100.0%

Space Separator

Value	Count	Frequency (%)
	148248	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2816712	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1051749	37.3%
2	325551	11.6%
1	314061	11.1%
-	296496	10.5%
:	296496	10.5%
	148248	5.3%
3	64875	2.3%
8	57162	2.0%
7	57114	2.0%
9	56418	2.0%
Other values (3)	148542	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2816712	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1051749	37.3%
2	325551	11.6%
1	314061	11.1%
-	296496	10.5%
:	296496	10.5%
	148248	5.3%
3	64875	2.3%
8	57162	2.0%
7	57114	2.0%
9	56418	2.0%
Other values (3)	148542	5.3%

time
Numeric time series

UNIFORM UNIQUE

Distinct	148248
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	74123.5
Minimum	0
Maximum	148247
Zeros	1
Zeros (%)	< 0.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	7412.35
Q1	37061.75
median	74123.5
Q3	111185.25
95-th percentile	140834.65
Maximum	148247
Range	148247
Interquartile range (IQR)	74123.5

Descriptive statistics

Standard deviation	42795.656
Coefficient of variation (CV)	0.57735611
Kurtosis	-1.2
Mean	74123.5
Median Absolute Deviation (MAD)	37062
Skewness	0
Sum	1.0988661 × 10¹⁰
Variance	1.8314681 × 10⁹
Monotonicity	Strictly increasing
Augmented Dickey-Fuller test p-value	0

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
98880	1	< 0.1%
98828	1	< 0.1%
98829	1	< 0.1%
98830	1	< 0.1%
98831	1	< 0.1%
98832	1	< 0.1%
98833	1	< 0.1%
98834	1	< 0.1%
98835	1	< 0.1%
Other values (148238)	148238	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
148247	1	< 0.1%
148246	1	< 0.1%
148245	1	< 0.1%
148244	1	< 0.1%
148243	1	< 0.1%
148242	1	< 0.1%
148241	1	< 0.1%
148240	1	< 0.1%
148239	1	< 0.1%
148238	1	< 0.1%

ACF and PACF

estacao
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

inverno	38352
verão	36816
outono	36768
primavera	36312

Length

Max length	9
Median length	7
Mean length	6.7451837
Min length	5

Characters and Unicode

Total characters	999960
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	outono
2nd row	outono
3rd row	outono
4th row	outono
5th row	outono

Common Values

Value	Count	Frequency (%)
inverno	38352	25.9%
verão	36816	24.8%
outono	36768	24.8%
primavera	36312	24.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
inverno	38352	25.9%
verão	36816	24.8%
outono	36768	24.8%
primavera	36312	24.5%

Most occurring characters

Value	Count	Frequency (%)
o	185472	18.5%
r	147792	14.8%
n	113472	11.3%
v	111480	11.1%
e	111480	11.1%
i	74664	7.5%
a	72624	7.3%
ã	36816	3.7%
u	36768	3.7%
t	36768	3.7%
Other values (2)	72624	7.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	999960	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	185472	18.5%
r	147792	14.8%
n	113472	11.3%
v	111480	11.1%
e	111480	11.1%
i	74664	7.5%
a	72624	7.3%
ã	36816	3.7%
u	36768	3.7%
t	36768	3.7%
Other values (2)	72624	7.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	999960	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	185472	18.5%
r	147792	14.8%
n	113472	11.3%
v	111480	11.1%
e	111480	11.1%
i	74664	7.5%
a	72624	7.3%
ã	36816	3.7%
u	36768	3.7%
t	36768	3.7%
Other values (2)	72624	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	963144	96.3%
None	36816	3.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	185472	19.3%
r	147792	15.3%
n	113472	11.8%
v	111480	11.6%
e	111480	11.6%
i	74664	7.8%
a	72624	7.5%
u	36768	3.8%
t	36768	3.8%
p	36312	3.8%

None

Value	Count	Frequency (%)
ã	36816	100.0%

Auto

Heatmap
Table

	chuva	pressao	radiacao	temperatura	temperatura_orvalho	temp_max_hr_anterior	temp_min_hr_anterior	umidade_max_hr_anterior	umidade_min_hr_anterior	umidade	vento_direcao	vento_velocidade	time	estacao
chuva	1.000	-0.182	-0.044	-0.062	0.258	-0.052	-0.042	0.294	0.250	0.295	0.040	0.011	0.005	0.032
pressao	-0.182	1.000	-0.046	-0.441	-0.567	-0.434	-0.488	0.025	0.030	0.008	-0.155	0.005	0.013	0.356
radiacao	-0.044	-0.046	1.000	0.561	-0.019	0.539	0.475	-0.454	-0.519	-0.549	-0.038	0.237	0.083	0.073
temperatura	-0.062	-0.441	0.561	1.000	0.345	0.987	0.979	-0.687	-0.715	-0.721	0.001	0.229	0.040	0.261
temperatura_orvalho	0.258	-0.567	-0.019	0.345	1.000	0.310	0.368	0.308	0.286	0.297	0.042	-0.065	0.004	0.415
temp_max_hr_anterior	-0.052	-0.434	0.539	0.987	0.310	1.000	0.976	-0.721	-0.758	-0.742	0.011	0.245	0.037	0.252
temp_min_hr_anterior	-0.042	-0.488	0.475	0.979	0.368	0.976	1.000	-0.680	-0.683	-0.677	0.015	0.241	0.045	0.274
umidade_max_hr_anterior	0.294	0.025	-0.454	-0.687	0.308	-0.721	-0.680	1.000	0.966	0.968	0.050	-0.348	-0.054	0.139
umidade_min_hr_anterior	0.250	0.030	-0.519	-0.715	0.286	-0.758	-0.683	0.966	1.000	0.981	0.036	-0.329	-0.045	0.136
umidade	0.295	0.008	-0.549	-0.721	0.297	-0.742	-0.677	0.968	0.981	1.000	0.058	-0.333	-0.050	0.136
vento_direcao	0.040	-0.155	-0.038	0.001	0.042	0.011	0.015	0.050	0.036	0.058	1.000	-0.007	0.001	0.092
vento_velocidade	0.011	0.005	0.237	0.229	-0.065	0.245	0.241	-0.348	-0.329	-0.333	-0.007	1.000	-0.038	0.080
time	0.005	0.013	0.083	0.040	0.004	0.037	0.045	-0.054	-0.045	-0.050	0.001	-0.038	1.000	0.122
estacao	0.032	0.356	0.073	0.261	0.415	0.252	0.274	0.139	0.136	0.136	0.092	0.080	0.122	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	chuva	pressao	radiacao	temperatura	temperatura_orvalho	temp_max_hr_anterior	temp_min_hr_anterior	umidade_max_hr_anterior	umidade_min_hr_anterior	umidade	vento_direcao	vento_velocidade	data_hora	time	estacao
0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 00:00:00	0	outono
1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 01:00:00	1	outono
2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 02:00:00	2	outono
3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 03:00:00	3	outono
4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 04:00:00	4	outono
5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 05:00:00	5	outono
6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 06:00:00	6	outono
7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 07:00:00	7	outono
8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 08:00:00	8	outono
9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2006-06-08 09:00:00	9	outono

	chuva	pressao	radiacao	temperatura	temperatura_orvalho	temp_max_hr_anterior	temp_min_hr_anterior	umidade_max_hr_anterior	umidade_min_hr_anterior	umidade	vento_direcao	vento_velocidade	data_hora	time	estacao
148238	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 14:00:00	148238	outono
148239	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 15:00:00	148239	outono
148240	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 16:00:00	148240	outono
148241	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 17:00:00	148241	outono
148242	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 18:00:00	148242	outono
148243	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 19:00:00	148243	outono
148244	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 20:00:00	148244	outono
148245	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 21:00:00	148245	outono
148246	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 22:00:00	148246	outono
148247	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-05-06 23:00:00	148247	outono

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

None

Interactions

Correlations

Missing values

Sample